All Questions
48 questions
0votes
0answers
58views
Sharepoint List not opening Edit form after New
I have a Sharepoint list that has two linked Power Apps forms - one for New and one for Edit. Everything seems to be working fine, aprt from: If I double click on a record or click and choose Edit, ...
0votes
0answers
61views
Amending drop down box options using JSON in SharePoint list
Sorry I'm a complete beginner to using JSON. I have two drop down boxes within a SharePoint list and I wish to amend the choices on the second drop down box based on the selection made from the first. ...
0votes
1answer
105views
Adding custom hover text using json to a MS List column
I found the below code on this website and it is just what I've been looking for for some time. The problem I'm having with code is that if I change the name of the column to something other than &...
0votes
1answer
25views
JSON for SharePoint to ignore blank date
I need to format a SharePoint Date column to be red if it is late and ignore blanks because it is coloring the blanks red. This is my current code. { "$schema": "https://developer....
0votes
0answers
307views
Gantt Formatting in Sharepoint list
Topic that often does the rounds, in relation to a Gantt style view in modern Sharepoint. TLDR: assistance required in amending position of bars within and them linking/ displaying correctly to dates ...
0votes
0answers
80views
Need help adding JSON code to existing code (Sharepoint List in gallery view)
Ok, very new to JSON and coding Sharepoint Lists. I found a great tutorial on how to generate a list and 'transform' it into a beautiful gallery card view . link in case above didn't work: https://www....
0votes
1answer
76views
Figuring out a Json format for the background to change colour for multiple values
I am wanting to format a column so it can automatically recognize different phrases and change the background of that cell to the same color. So for example I may have 5 rows of data in one column: ...
0votes
1answer
133views
SharePoint List formatting a Date column
I have a SharePoint list with a date column. I want to format the Dates in the column to be centered with Bold Red Text and keep using the existing background color, if the date is within the last 7 ...
0votes
1answer
281views
Adding a URL Under a Title Header
I currently have a title header using JSON in a SharePoint list that works as I would like it to. I want to add a URL under the Title which points to a standard operating procedure outlining how to ...
0votes
1answer
107views
Use JSON to calculate Average
Can anyone please help !! Im using a 2x SharePoint Online lists. One list contains a REGISTER One list contains a list of ACTIONS to be taken against items on the REGISTER list I have managed to ...
0votes
2answers
1kviews
Hide/Remove "Edit All", "Show Comment" and the directory path from a list form in display mode
I have the following issue. I have a SharePoint list form (open in display mode which means every field can be edited and saves automatically) and I would like to hide/remove the "Edit All" ...
1vote
1answer
2kviews
JSON formatting: make some words inside body text of email bold
I know how to make text bold in its entirety, but is there a way to make SOME text within my email body bold? Example: "&body=This is a test" How do I only make the word 'test' bold ...
0votes
1answer
223views
Background color of fields according to input - SharePoint Online List
I know nothing about JSON but I need to get JSON that will allow me to set the background color field of a "Status" field based on the selected "Status" - i.e selection of yellow ...
1vote
1answer
192views
MS List Conditional Formatting JSON with SharePoint 365
I've reviewed a lot of threads and none seem to quite fit my fact pattern. I'm using the Modern MS Lists, in Office 365 Online. We have a list of contracts that we want to color code rows based on ...
0votes
1answer
185views
What is the most efficient approach to pulling data (using Vue) from a SP list to then export it to Excel?
I've run across many descriptions on how to effectively/efficiently set up a click event that pulls data from a single SharePoint list and then exports the data to Excel in a Vue.js environment. So ...